CREATE TABLE [dbo].[Order_Badge]
(
[ORDER_NUMBER] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Order_Badge_ORDER_NUMBER] DEFAULT ((0)),
[BADGE_NUMBER] [int] NOT NULL CONSTRAINT [DF_Order_Badge_BADGE_NUMBER] DEFAULT ((0)),
[BADGE_TYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_BADGE_TYPE] DEFAULT (''),
[FULL_NAME] [varchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_FULL_NAME] DEFAULT (''),
[TITLE] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_TITLE] DEFAULT (''),
[COMPANY] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_COMPANY] DEFAULT (''),
[FULL_ADDRESS] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_FULL_ADDRESS] DEFAULT (''),
[PREFIX] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_PREFIX] DEFAULT (''),
[FIRST_NAME] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_FIRST_NAME] DEFAULT (''),
[MIDDLE_NAME] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_MIDDLE_NAME] DEFAULT (''),
[LAST_NAME] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_LAST_NAME] DEFAULT (''),
[SUFFIX] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_SUFFIX] DEFAULT (''),
[DESIGNATION] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_DESIGNATION] DEFAULT (''),
[INFORMAL] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_INFORMAL] DEFAULT (''),
[ADDRESS_1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_ADDRESS_1] DEFAULT (''),
[ADDRESS_2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_ADDRESS_2] DEFAULT (''),
[CITY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_CITY] DEFAULT (''),
[STATE_PROVINCE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_STATE_PROVINCE] DEFAULT (''),
[ZIP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_ZIP] DEFAULT (''),
[COUNTRY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_COUNTRY] DEFAULT (''),
[BAR_CODE] [varchar] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_BAR_CODE] DEFAULT (''),
[DELEGATE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ST_PRINT_COMPANY] [bit] NOT NULL CONSTRAINT [DF_Order_Badge_ST_PRINT_COMPANY] DEFAULT ((0)),
[ST_PRINT_TITLE] [bit] NOT NULL CONSTRAINT [DF_Order_Badge_ST_PRINT_TITLE] DEFAULT ((0)),
[ADDRESS_3] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Badge_ADDRESS_3] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Order_Badge] ADD CONSTRAINT [PK_Order_Badge] PRIMARY KEY CLUSTERED ([ORDER_NUMBER], [BADGE_NUMBER]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Order_Badge] TO [IMIS]
GRANT SELECT ON  [dbo].[Order_Badge] TO [IMIS]
GRANT INSERT ON  [dbo].[Order_Badge] TO [IMIS]
GRANT DELETE ON  [dbo].[Order_Badge] TO [IMIS]
GRANT UPDATE ON  [dbo].[Order_Badge] TO [IMIS]
GO